/* 积水点等级原因*/
alter table t_pond
    add level_cause nvarchar(255)
GO
	EXEC sp_addextendedproperty 'MS_Description',
	N'积水点等级原因',
	'SCHEMA',
	N'dbo',
	'TABLE',
	N't_pond',
	'COLUMN',
	N'level_cause'
/*责任人单位*/
ALTER TABLE t_pond
    ADD duty_person_monomer nvarchar ( 255 )
GO
	EXEC sp_addextendedproperty 'MS_Description',
	N'责任人单位',
	'SCHEMA',
	N'dbo',
	'TABLE',
	N't_pond',
	'COLUMN',
	N'duty_person_monomer'
/*责任人职务*/
ALTER TABLE t_pond
    ADD duty_person_post nvarchar ( 255 )
GO
	EXEC sp_addextendedproperty 'MS_Description',
	N'责任人职务',
	'SCHEMA',
	N'dbo',
	'TABLE',
	N't_pond',
	'COLUMN',
	N'duty_person_post'
/*积水原因下拉(多选下拉，逗号隔开)*/
ALTER TABLE t_work_reported_water_points
    ADD ponding_cause_three nvarchar ( 255 )
GO
	EXEC sp_addextendedproperty 'MS_Description',
	N'积水原因下拉(多选下拉，逗号隔开)',
	'SCHEMA',
	N'dbo',
	'TABLE',
	N't_work_reported_water_points',
	'COLUMN',
	N'ponding_cause_three'
/*整治状态*/
ALTER TABLE t_pond
    ADD cure_type bigint GO
	EXEC sp_addextendedproperty 'MS_Description',
	N'整治情况1:已整治 2:未整治',
	'SCHEMA',
	N'dbo',
	'TABLE',
	N't_pond',
	'COLUMN',
	N'cure_type'
/*历史等级改为非必填*/
ALTER TABLE [dbo].[t_pond_adjust_process] ALTER COLUMN [old_level] int
/*同上*/
ALTER TABLE [dbo].[t_pond_level_log] ALTER COLUMN [last_level] int

ALTER TABLE [dbo].[t_pond_adjust_process] ALTER COLUMN [cause_str] nvarchar(255)

ALTER TABLE [dbo].[t_pond_adjust_process] ALTER COLUMN [new_level] nvarchar(255)

ALTER TABLE [dbo].[t_pond] ALTER COLUMN [level] int

ALTER TABLE [dbo].[t_pond_level_log] ALTER COLUMN [now_level] int

CREATE TABLE dbo.t_daily_report
(
    id
    bigint
    NOT
    NULL,
    create_user
    bigint
    NULL,
    create_dept
    bigint
    NULL,
    create_time
    datetime
    NULL,
    update_user
    bigint
    NULL,
    update_dept
    bigint
    NULL,
    update_time
    datetime
    NULL,
    is_deleted
    int
    DEFAULT
    0
    NULL,
    report_region_name
    nvarchar
(
    255
) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    report_region_code nvarchar
(
    255
) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    report_district nvarchar
(
    255
) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    report_district_code nvarchar
(
    255
) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    report_deatail ntext COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    status int NULL,
    create_user_name nvarchar
(
    255
) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    report_time datetime NULL,
    CONSTRAINT PK__t_daily___3213E83FA150B8A8 PRIMARY KEY
(
    id
)
    );
